Tiny File Manager | hub_log_maintain

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: Maintain  HUB_LOG
//
// Programmer: AR
// Date      : 2024-07-18
//
// Copyright Reeft A/S (c) - 2024
//======================================================================================

// https://stackoverflow.com/questions/56062658/clicking-programmatically-on-the-arrows-of-html-inputs-type-number
// https://datatables.net/manual/server-side
// https://datatables.net/examples/data_sources/server_side

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Make line uppercase
//======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Check if user is logged in?
//======================================================================================
	include "login_check.php";

//======================================================================================
// Get session variables
//======================================================================================

include "include/getsession.php";

// include "include/uuid_create.php";
	// include "include/generate_password_md5.php";

//======================================================================================
// Set language
//======================================================================================

include "include/set_language.php";

//======================================================================================
// Set defaults
//======================================================================================

// $pk_reference  = $_SESSION['session_dft_pk_reference'];
	// $referenceCode = $_SESSION['session_dft_referencecode'];
	// $referenceName = $_SESSION['session_dft_referencename'];

//======================================================================================
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<title><?php echo $datahub_text0001 ?></title>

<link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet">
    <link href="css/bootstrap4.3.1/css/themes/bootstrap.custom.min.css" rel="stylesheet">

<link href="css/custom.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">

.btn-custom-wide {
	height:60px;
	width:210px;
}

.text-truncate-dt {
    max-width: 450px;
	white-space: nowrap;
    overflow: hidden;
	text-overflow: ellipsis;
	
}
.modal-xxl {
    max-width: 80%;
}

.modal-xl {
    max-width: 50%;
}

.border-3 {
    border-width:3px !important;
}

td .hover-img {
  position:relative;
 }
td .hover-img span {
  position:absolute; left:-9999px; top:-9999px; z-index:9999;
 }
td:hover .hover-img span {
  top: 5px;
  left:0px;
 }

.chosen-container-single {
    min-width: 100%;
}

</style>

//=============================================================================
// Globals
//=============================================================================
	
    var thisCurrentRow;
	var thisGlobalRowData;
    var thisGlobalTableData;
	
	// date variables
	var input_fromdate;
	var input_fromtime;
	var input_todate;
	var input_totime;
	
	var global_debug = 'N';

// Add allowed Y/N
	var GLOBAL_ADD_ALLOWED = 'N';

// Delete allowed Y/N
	var GLOBAL_DELETE_ALLOWED = 'N';
	
	// sortMode
	var GLOBAL_SORTMODE = 'DESC';

var jsonDataSave = {};

var DFT_DATE_DISPLAY_FORMAT 	=  '<?php //echo $DFT_DATE_DISPLAY_FORMAT ?>';
	var DFT_LANGUAGE 				=  '<?php //echo $DFT_LANGUAGE ?>';

var GLOBAL_TOTALPAGESSTOPVALUE	=  10;

// Save field
	//var save_CFGNAM = '';

$(function () {
	  $.scrollUp({
		scrollName: 'scrollUp', // Element ID
		//topDistance: '1800', // Distance from top before showing element (px)
		//topSpeed: 300, // Speed back to top (ms)
		scrollDistance: '300', // Distance from top before showing element (px)
		scrollSpeed: 300, // Speed back to top (ms)
		animation: 'fade', // Fade, slide, none
		animationInSpeed: 200, // Animation in speed (ms)
		animationOutSpeed: 200, // Animation out speed (ms)
		scrollText: false, //'Scroll to top', // Text for element
		activeOverlay: false, // Set CSS color to display scrollUp active point, e.g '#00FFFF'
	  });
	});

//=============================================================================
// Get data
//=============================================================================
function getData( input )
{

// Reset, show all
	if ( input == '*RESET' ) {
		input = '';
		$('#input-show-next-prodid').val('N');
		$('#input-fromdate').val('');
		$('#input-fromtime').val('');
		$('#input-todate').val('');
		$('#input-totime').val('');
		
		// Update input variables 
		input_fromdate = $('#input-fromdate').val();
		input_fromtime = $('#input-fromtime').val();
		input_todate = $('#input-todate').val();
		input_totime = $('#input-totime').val();
		
		//Clear search
		thisGlobalTableData.search( '' );
		
	}
	
	//Only initialize datatables once, else just draw it 
	if ( $.fn.dataTable.isDataTable( '#REEFTvisual_data' ) ) {
		thisGlobalTableData.draw(); // fire in the hole
	}
	else {
		setDataTables();
	}

}

//=============================================================================
// Set datatables
//=============================================================================
function setDataTables()
{

// Delete allowed?
	GLOBAL_DELETE_ALLOWED = 'N';

if ( GLOBAL_DELETE_ALLOWED == 'Y' ) {
		var show_the_delete_button = true;
	} else {
		var show_the_delete_button = false;
	}
	
	// Get the current date line
	input_fromdate = $('#input-fromdate').val();
	input_fromtime = $('#input-fromtime').val();
	input_todate = $('#input-todate').val();
	input_totime = $('#input-totime').val();

$('#REEFTvisual_data').DataTable({
		"ajax": {
			"url": 'hub_log_maintain_get.php',
			"data": function (parmData) {
				// add custom parameters to the ajax call 
				// parmData.custom = $('#myInput').val();
				if (input_fromdate.trim() != '') 	parmData.fromdate 	= input_fromdate.trim();
				if (input_fromtime.trim() != '') {
					input_fromtime = input_fromtime.concat(":00");
					parmData.fromtime = input_fromtime;
				}
				if (input_todate.trim() != '') 		parmData.todate 	= input_todate.trim();
				if (input_totime.trim() != '') {
					input_totime = input_totime.concat(":00");
					parmData.totime = input_totime;
				}
				
				// Add custom parameters to the ajax call

// Webservice name
				parmData.hub_webnam	 = input_hub_webnam;

// From date
				parmData.fromdate 	= input_fromdate.trim();
				parmData.fromtime = input_fromtime;

// To date
				parmData.todate 	= input_todate.trim();
				parmData.totime = input_totime;

},
			dataSrc: function (jsonData) {  //return data
			
				var myCMPNO				= jsonData.header.myCMPNO;
				var myCMPNO_Name		= jsonData.header.myCMPNO_Name;
				var myFile_name			= jsonData.header.myFile_name
				var myFile_description	= jsonData.header.myFile_description
				
				var returnCode 			= jsonData.header.returnCode;
				var returnMsg 			= jsonData.header.returnMsg;
				var entries_found 		= jsonData.header.entries_found;
				var response_sec 		= jsonData.header.response_sec;
				
				// Show load time
				$('#load-time-from-database').html('entries found: ' + entries_found + ' (' + response_sec + ')');
				
				return jsonData.data;
			}
		},
		"processing": true,
		"serverSide": true,
        "responsive": true,
		"fixedHeader": true,
		"lengthMenu": [[10, 25, 50, 100, 250], [10, 25, 50, 100, 250]],
		"iDisplayLength": 25,
		"dom": 'lfip<bottom>Bp<"clear">',
        "order": [[ 0, "desc" ]],
		"columns":  [
                    { data: "TIMESTAMP" },
                    { data: "LOGCODE" },
                    { data: "LOGPGM" },
                    { data: "DATALINE" },
                    { defaultContent: '<button class="edit-btn btn btn-primary mr-1"><?php echo $datahub_button_show_details ?></button>' },
                    { defaultContent: '<button class="delete-btn btn btn-danger"><?php echo $datahub_button_delete ?></button>'},
                ],
		"columnDefs": [
				{
				"targets": [ 4 ],
				"visible": true,
				"searchable": false,
				 "orderable": false
				},
				{
				"targets": [ 5 ],
				"visible": show_the_delete_button,
				"searchable": false,
				 "orderable": false
				},
				{
				"targets": [ 3 ],
				"className": "text-truncate-dt"  //class to mimic text-truncate in dt
				},

],
		"language":
		{
					"processing": 	 "<i class=\"fa fa-spinner fa-spin fa-3x fa-fw\"></i><span class=\"sr-only\"><?php echo $datahub_datatable_Processing ?></span>",
					"sProcessing":   "<?php echo $datahub_datatable_Processing ?>",
					"sLengthMenu":   "<?php echo $datahub_datatable_LengthMenu ?>",
					"sZeroRecords":  "<?php echo $datahub_datatable_ZeroRecords ?>",
					"sInfo":         "<?php echo $datahub_datatable_Info ?>",
					"sInfoEmpty":    "<?php echo $datahub_datatable_InfoEmpty ?>",
					"sInfoFiltered": "<?php echo $datahub_datatable_InfoFiltered ?>",
					"sInfoPostFix":  "<?php echo $datahub_datatable_InfoPostFix ?>",
					"sLoadingRecords": "<?php echo $datahub_datatable_Processing ?>",
					"sSearch":       "<?php echo $datahub_datatable_Search ?>",
					"sUrl":          "<?php echo $datahub_datatable_Url ?>",
					"oPaginate": {
						"sFirst":    "<?php echo $datahub_datatable_First ?>",
						"sPrevious": "<?php echo $datahub_datatable_Previous ?>",
						"sNext":     "<?php echo $datahub_datatable_Next ?>",
						"sLast":     "<?php echo $datahub_datatable_Last ?>"
					}
		},
        "rowCallback": function(row, data, index)
		{

},
        "preDrawCallback": function(settings)
		{
		},
		"initComplete": function ()
		{
			
		},
		"buttons": 	[
					{
						extend: 'pdf',
						text: '<img src="images/pdf_logo.png" height="25"> PDF',
						orientation: 'landscape',
						title: 'Config - Data Export - PDF',
						exportOptions: {
						modifier: {
							page: 'all'
							}
						}
					},
					{
						extend: 'excel',
						text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel',
						title: 'Config Data Export - Excel',
						},
						{
						extend: 'copy',
						text: '<img src="images/copy.png" height="25"> Copy to Clipboard',
						title: 'Config Data Export - Copy',
						},
					]
    });

//=============================================================================
	// Setup the data to be able to update the table without reloading from the server
	//=============================================================================

// Save the table in a global variable
		thisGlobalTableData = $('#REEFTvisual_data').DataTable();

// Handle click on "Edit" button
		$('#REEFTvisual_data tbody').on('click', '.edit-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log("edit");
			// console.log(thisGlobalRowData);
			// console.log(thisCurrentRow);
			 
			 dataShow();

});
		
		// Handle click on "Edit" button
		$('#REEFTvisual_data tbody').on('click', '.delete-btn', function() {
			thisCurrentRow 	= $(this).closest('tr');
			thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data();

// Debug
			// console.log(thisGlobalRowData);
			// console.log(thisCurrentRow);
			
			dataDeleteConfirm();

});

//=============================================================================

}

//=============================================================================
// Reason addd  -- not used
//=============================================================================
function dataAdd ( input_pk_type )
{

$('#input-mode').val('*add');

$('#modal-input-ACTIVE').val('Y');		// Active
			$('#modal-input-CFGNAM').val('');		// DATA-HUB cfg name
			$('#modal-input-CFGTYP').val('');		// DATA-HUB cfg type
			$('#modal-input-CFGDSC').val('');		// Config description
			$('#modal-input-CFGVAL').val('');		// DATA-HUB cfg value
			$('#modal-input-CFGDAT').val('');		// Create date
			$('#modal-input-CFGTIM').val('');		// Create time

// Reset save field(s)
			//save_CFGNAM = '';

// Set active - default YES
			$('#button-deleted-yes').removeClass('btn-primary').addClass('btn-success');
			$('#button-deleted-no').removeClass('btn-success').addClass('btn-primary');

// Reset modal message
			resetModalMessage();

// Remove key fields readonly
			$('#modal-input-CFGNAM').removeAttr('readonly','readonly');
			$('#data-result-button-lines-modal').removeClass('d-none');

// Show modal
			$('#log_MaintainModal').modal('show');

$('#log_MaintainModal').on('shown.bs.modal', function () {
				//$('#modal-input-WZLIN').trigger('focus');
				$('#modal-input-CFGNAM').trigger('focus');
			})

}

//=============================================================================
// Show details
//=============================================================================
function dataShow( )
{

$('#input-mode').val('*update');
	
	var row = thisGlobalRowData;

// Save in fields
	var TIMESTAMP = row["TIMESTAMP"];
	var LOGCODE	  = row["LOGCODE"];
	var LOGPGM	  = row["LOGPGM"];
	var DATALINE  = row["DATALINE"];
	var counter   = row["counter"];

// Move to input fields
	$('#modal-input-counter').val(counter); 	// counter (used as id)
	$('#modal-input-TIMESTAMP').val(TIMESTAMP);	// timestamp
	$('#modal-input-LOGCODE').val(LOGCODE);		// Log code
	$('#modal-input-LOGPGM').val(LOGPGM);		// Log program
	$('#modal-input-DATALINE').val(DATALINE);	// Log line

// Make key fields readonly
	$('#modal-input-DATALINE').attr('readonly','readonly');
	$('#data-result-button-lines-modal').addClass('d-none');

$('.read-only-class').attr('readonly','readonly');

// Reset modal message
	resetModalMessage();

// Show modal
	$('#log_MaintainModal').modal('show');

$('#log_MaintainModal').on('shown.bs.modal', function () {
		//$('#modal-input-WZSEQ').trigger('focus');

//myWZDON = thisGlobalRowData[7];
		//setWZDON_button( myWZDON );

})

}

//=============================================================================
// Delete confirm
//=============================================================================
function dataDeleteConfirm( )
{

$('#input-mode').val('*delete');
	
	var row = thisGlobalRowData;
	
	var input_TIMESTAMP = row["TIMESTAMP"];

$('#confirm-delete-HUB_TIMESTAMP').val(input_TIMESTAMP);

// Create confirm text
	$('#confirm-delete-text-TIMESTAMP').html(input_TIMESTAMP);

$('#config_confirmDeleteModal').modal('show');

}

//=============================================================================
// Delete
//=============================================================================
function dataDeleteExec()
{
	// Reset modal message
	resetModalMessage();

var mode = $('#input-mode').val();

// Make array and json
	var myData = $('#dataForm-delete').find('input, select').serializeArray();
	var result = JSON.stringify(myData);

//we don't use delete for now so return here...
	// console.log(result);
	 console.log(myData);
	return;

var parmData = 'data=' + result
				 + '&mode=' + mode
				 ;

$.ajax({
		url: "hub_config_maintain_save.php",
		type: "POST",
		data: parmData,
		dataType: "json",
		cache: false,
	})
	.done(function( jsonData ) {

$('#config_confirmDeleteModal').modal('hide');
		getData('');

})
	.always(function( jsonData ) {

})
	.fail(function( xhr, ajaxOptions, thrownError ) {
		console.log('I am failed..');
		console.log( xhr );

});

}

//=============================================================================
// Show deleted
//=============================================================================
function showDeleted()
{

var show_deleted = $('#input-show-deleted').val();

if ( show_deleted == 'Y' ) {
		$('#button-show-deleted').html('<?php echo $datahub_NO ?>');
		$('#input-show-deleted').val('N');
	} else {
		$('#button-show-deleted').html('<?php echo $datahub_YES ?>');
		$('#input-show-deleted').val('Y');
	}

getData('');

}

//=============================================================================
// Log off
//=============================================================================
function signoff()
{

window.location.href = "logout.php";

}

//=============================================================================
// Load page
//=============================================================================
function loadPage(url, p1, p2, p3)
{

window.location.href = url;

}

//=============================================================================
// Reset modal message
//=============================================================================
function resetModalMessage() {

// Reset
	//$('#modal-message').removeClass('p-2 font-weight-bold border border-danger rounded bg-light').html( '&nbsp;' );

$('#modal-message').removeClass('border-bottom').html( '&nbsp;' );
	$('#modal-save-button').removeClass('disabled').prop("disabled", false);

}

//=============================================================================
// Clean input string
//=============================================================================
function cleanInputString( myWorkField )
{

let charactersToRemove = '?#"\'';
	let myPattern = new RegExp('[' + charactersToRemove + ']', 'g');

myWorkField = myWorkField.replace(myPattern,'');

return myWorkField;

}

//=============================================================================
// Full screen popup
//=============================================================================
function popUpFull( url, p1, p2, p3 )
{

var winname = 'win_' + url;

params  = 'width='+screen.width;
	params += ', height='+screen.height;
	params += ', top=0, left=0'
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;

}

//=============================================================================
// screen popup - center
//=============================================================================
function popUpCenter(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

if ( parseInt(v1_w) > 1800 ) {
		v1_w = 1800;
		v1_h = v1_h - 200;
		v1_center = v1_w/0.8;
	}

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;

}

//=============================================================================
// screen popup - center - bigger
//=============================================================================
function popUpCenterBig(url, p1, p2, p3)
{

var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

// Get 25%
	v1_w_pct = v1_w * 0.25;

v1_w_new = v1_w - v1_w_pct;

if ( v1_w_new < 1 ) {
		v1_w_new	= 1800;
	}

v1_w = v1_w_new;
	v1_h = v1_h - 200;
	v1_center = v1_w/0.8;

// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

var winname = 'win_' + url;

params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;

}

//=============================================================================
// Popup top
//=============================================================================
function popUpTop(url, p1, p2, p3)
{

var winname = 'win_' + url;

w = 650;
	h = 750;

params  = 'width='+w;
	params += ', height='+h;
	params += ', top=0, left=0'
	params += ', fullscreen=no';
	params += ',scrollbars=1';

overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;
}

//=============================================================================
// Set clock
//=============================================================================
function updateClock() {

var currentTime = moment().format('YYYY-MM-DD HH:mm:ss');
	currentTime = REEFT_format_date( currentTime, DFT_DATE_DISPLAY_FORMAT )

$('#current-time').html( currentTime );

}

//=============================================================================
// jQuery - Ready
//=============================================================================
$(document).ready(function()
{

// Do not show deleted
	$('#input-show-deleted').val('Y');

// Get data done by datatables
	setDataTables();

//-----------------------------------------------------------------------
	// Start the clock
	//-----------------------------------------------------------------------
		updateClock();
		setInterval(function() {
			updateClock();
		}, 1000); 
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Set font awesome icon type
	//-----------------------------------------------------------------------
	// Value is from config/config.php
	var iconType = '<?php echo $DFT_SET_FONT_AWESOME_ICON_TYPE ?>';
	setFontAwesomeIconType( iconType );
	//-----------------------------------------------------------------------

//-----------------------------------------------------------------------
	// Delay keyup checker
	//-----------------------------------------------------------------------
	var delay = (function () {
		var timer = 0;
		return function (callback, ms) {
			clearTimeout(timer);
			timer = setTimeout(callback, ms);
		};
	})()

// DataTable search delay
	$('#REEFTvisual_data_wrapper .dataTables_filter input')
    .unbind() // overrule normal behavior
    .bind('keyup', function(e){
		var inputValue = $('.dataTables_filter input').val();
		var currSearchValue = $('#input-search-line').val();
		if (inputValue != currSearchValue) {
			$('#input-search-line').val( inputValue );
			//If enter or delete we update immediately, consider to add backspace=8 also
			const keyList = [13,46];
			if (keyList.includes(e.keyCode)) {
				// console.log('immediately ' + inputValue );
				thisGlobalTableData.search(inputValue).draw(); // fire in the hole
			} else {
				delay(function () {
					// console.log('this will hit, once user has not typed for 1 second ' + inputValue );
					thisGlobalTableData.search(inputValue).draw(); // fire in the hole
				}, 0800);
			}
		}
	});
	
	//-----------------------------------------------------------------------
	// Event listener for the update button
	//-----------------------------------------------------------------------
    $('#updateButton').on('click', function() {
        // Update input variables 
		input_fromdate = $('#input-fromdate').val();
		input_fromtime = $('#input-fromtime').val();
		input_todate = $('#input-todate').val();
		input_totime = $('#input-totime').val();

// Trigger a redraw of the table
        thisGlobalTableData.draw();
    });

//-----------------------------------------------------------------------
	// Set short cuts
	//-----------------------------------------------------------------------

// If add d-none class, do not add shortcut
	if ( GLOBAL_ADD_ALLOWED == 'Y' ) {
		shortcut.add("Alt+F6",function() {
			$('#add-button').click();
		});
	}

});
// -->
</script>

</head>

<body>

</div>
				</div>
			</div>

<div class="container-fluid mt-2 mb-4 d-block d-lg-none">
					<div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div>
				</div>

<div class="row mb-4">
					<div class="col-10">
						<div id="data-result-button-lines"></div>
					</div>
					<div class="col-2 text-right">

</div>
				</div>

</div>

<?php
	include "include/footer.php";
?>

<div class="modal fade" id="log_MaintainModal" tabindex="-1" data-backdrop="static" role="dialog" aria-labelledby="log_MaintainModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xxl">
    <div class="modal-content">

<div class="col text-right">
				
			</div>
			<div class="col-1 text-right" style="max-width:20px">
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
				  <span aria-hidden="true">&times;</span>
				</button>
			</div>

</div>
		</div>

</div>
      <div class="modal-body ml-2 mr-2">

<input type="text" class="d-none" id="modal-input-counter" name="modal-input-counter">

</form>

</div>
      <div class="modal-footer-pretty modal-footer">

</div>

</div>
    </div>
  </div>
</div>

<div class="modal fade" id="config_confirmDeleteModal" tabindex="-1" role="dialog" aria-labelledby="config_confirmDeleteModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-xl" role="document">
    <div class="modal-content">
      <div class="modal-header bg-primary text-white">
        <h5 class="modal-title" id="config_confirmDeleteModalLabel"><?php echo $datahub_text0063 ?></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">

</form>

</div>
      <div class="modal-footer">

<div class="row mt-1 mb-2">
					<div class="col-3 text-left">
						<button type="button" onclick="dataDeleteExec()" class="btn btn-primary">Delete</button>
					</div>
					<div class="col-6 text-right">
					</div>
					<div class="col-3 text-right">
						<button type="button" class="btn btn-primary" data-dismiss="modal">Cancel</button>
					</div>
				</div>

</div>
      </div>
    </div>
  </div>
</div>

</body>
</html>